import pymysql

conn = pymysql.connect(host="localhost", user='root', password='123456', port=3306, db='spyder')
cursor = conn.cursor()

cursor.execute(
    r'''INSERT INTO movies (movie_name, country, duration, release_date, rating)
    VALUES ('霸王别姬 - Farewell My Concubine', '中国内地、中国香港', '171 分钟', '/', '["剧情","爱情"]')''')

conn.commit()